﻿--Default Values

SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO

-- Insert Offers
-- New items
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate)
	VALUES('kg', 1.3, 300, 6, (select top 1 Id from ProductSet where name = 'Pommes'), GETDATE())
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate)
	VALUES('kg', 0.9, 100, 6, (select top 1 Id from ProductSet where name = 'Carottes'), GETDATE())
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate)
	VALUES('barquette de 500g', 1.6, 220, 6, (select top 1 Id from ProductSet where name = 'Fraises'), GETDATE())
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate)
	VALUES('kg', 0.72, 880, 6, (select top 1 Id from ProductSet where name = 'Pommes de terre'), GETDATE())



	
-- Passed items
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate, CreationDate)
	VALUES('kg', 0.9, 300, 6, (select top 1 Id from ProductSet where name = 'Pommes'), GETDATE() - 7, GETDATE() - 7)
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate, CreationDate)
	VALUES('kg', 1, 100, 6, (select top 1 Id from ProductSet where name = 'Carottes'), GETDATE() - 7, GETDATE() - 7)
INSERT INTO OfferSet(Unit, Price, Quantity, SupplierId, ProductId, HarvestDate, CreationDate)
	VALUES('barquette de 250g', 1.1, 600, 7, (select top 1 Id from ProductSet where name = 'Fraises'), GETDATE() - 7, GETDATE() - 7)